How to: Change field properties to view unique values.
Solution:
Click in any blank cell, select the 'View' menu and select 'Properties', then select the 'Unique Values' box and select 'Yes' from the drop-down menu.
1) If the Database window is not active, activate the Database window.
2) Click the 'Queries' tab in the Database window.
Queries tab
3) Select the desired query. (The query is highlighted.)
4) Click 'Design'. (The query appears in query design view.)
5) Click in any blank cell.
6) Select the 'View' menu and select 'Properties'. (The property sheet appears.)
7) Click in the 'Unique Values' box. (A down arrow appears in the right-hand corner.)
8) Click arrow. (A drop-down list appears.)
9) Select 'Yes' from the drop-down list to view unique values in the query.
10) To close the property sheet, click the 'X' in the upper-right hand corner of the property sheet.
Click X button to close property sheet
NOTE: The properties will be saved only when the design view is saved.
